create external table jms_ods.tab_barscan_sign_delete
(
  billcode              string    comment  '运单编号'
,record_id             string    comment  '记录编号'
,scan_type             string    comment  '扫描类型'
,scan_time             string      comment  '扫描时间'
,upload_time           string      comment  '上传时间'
,input_time            string      comment  '入库时间'
,create_time           string      comment  '创建时间(删除记录入库时间)'
,delete_time           string      comment  '删除时间'
,delete_site_id        int       comment  '删除网点id'
,delete_site_code      string    comment  '删除网点编号'
,delete_site_name      string    comment  '删除网点名称'
,delete_user_code      string    comment  '删除员工编号'
,delete_user_name      string    comment  '删除员工姓名'
,scan_site_id          int       comment  '扫描网点id'
,scan_site_code        string    comment  '扫描网点编号'
,scan_site_name        string    comment  '扫描网点名称'
,scan_user_code        string    comment  '扫描员编号'
,scan_user_name        string    comment  '扫描员姓名'
,deliver_user_code     string    comment  '派件员编号'
,deliver_user_name     string    comment  '派件员姓名'
,scan_source           string    comment  '扫描来源'
,device_id             string    comment  '设备id'
,list_id               string    comment  '清单编号'
,create_type           int       comment  '数据产生类型(后台自动产生数据时才会有)'
,picture_flag          int       comment  '图片标识(快件签收)'
,payment_code          string    comment  '支付方式编号(快件签收)'
,signer                string    comment  '签收人(快件签收) 手机号码(出库扫描)'
,sign_type             string    comment  '签收类型(快件签收)'
,express_cabinet       string    comment  '快递柜地址(出库扫描)'
,partner_name          string    comment  '合作伙伴名称(出库扫描)'
,operation_source      string    comment  '操作来源编号(出库扫描)'
,real_operation_source string    comment  'pdd操作来源编号(出库扫描)'
,update_time           string      comment  '更新时间'
,extend_field_c01      string    comment  '扩展字段01(字符型)'
,extend_field_c02      string    comment  '扩展字段02(字符型)'
,extend_field_n01      int       comment  '扩展字段01(数值型)'
,extend_field_d01      string      comment  '扩展字段01(时间型)'
,extend_field_c03      string    comment  '扩展字段03(字符型)'
,extend_field_c04      string    comment  '扩展字段04(字符型)'
)comment  '签收删除表'
PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/tab_barscan_sign_delete'